SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.[DnnProduct_UpdateDesktopModulePermission]
	@DesktopModulePermissionID int, 
	@PortalDesktopModuleID int, 
	@PermissionID int, 
	@RoleID int ,
	@AllowAccess bit,
    	@UserID int,
	@LastModifiedByUserID	int
AS
    UPDATE dbo.DnnProduct_DesktopModulePermission 
    SET     
	    [PortalDesktopModuleID] = @PortalDesktopModuleID,
	    [PermissionID] = @PermissionID,
	    [RoleID] = @RoleID,
	    [AllowAccess] = @AllowAccess,
	    [UserID] = @UserID,
		[LastModifiedByUserID] = @LastModifiedByUserID,
		[LastModifiedOnDate] = getdate()
    WHERE   [DesktopModulePermissionID] = @DesktopModulePermissionID
GO
